Take Test: Test 340

Content

Assistive Technology Tips [opens in new window]

Test Information

Instructions

Description
Instructions
Timed Test	This test has a time limit of 1 hour.This test will save and submit automatically when the time expires. Warnings appear when half the time, 5 minutes, 1 minute, and 30 seconds remain.
Multiple Attempts	This test allows 3 attempts. This is attempt number 2.
Force Completion	This test can be saved and resumed at any point until time has expired. The timer will continue to run if you leave the test.

Remaining Time:
40 minutes, 07 seconds.

Question 1

A person, place, object, event, or concept about which the organization wishes to maintain data is called a(n):

		relationship.
		object.
		attribute.
		entity.

2 points

Question 2

The number of instances of one entity that is associated with each instance of another entity is called

		cardinality.
		number.
		identifying characteristic.
		degree

2 points

Question 3

In the diagram below depicts a(an)

		LEFT JOIN
		RIGHT JOIN
		FULL JOIN
		INNER JOIN

2 points

Question 4

In the SQL language, the ________ statement is used to make table definitions.

		CREATE SESSION
		CREATE INDEX
		SELECT
		CREATE TABLE

2 points

Question 5

Data names should always relate to business characteristics.

True

False

2 points

Question 6

In the SQL language, the ________ statement is used to change a table definition.

		ALTER TABLE
		CHANGE TABLE
		UPDATE TABLE
		AMEND TABLE

2 points

Question 7

An entity type whose existence depends on another entity type is called a ________ entity.

		strong
		weak
		codependent
		variant

2 points

Question 8

VARCHAR data type is a varying length string

True

False

2 points

Question 9

A relation that contains no multivalued attributes and has nonkey attributes solely dependent on the primary key but contains transitive dependencies is in which normal form?

		First
		Second
		Third
		Fourth

2 points

Question 10

A function where the values of multiple rows are grouped together as input on certain criteria to form a single value is called a(n):

		math function
		group by function
		collection function
		aggregate function

2 points

Question 11

An attribute (or attributes) that uniquely identifies each row in a relation is called a:

		primary key.
		column.
		foreign field.
		duplicate key.

2 points

Question 12

All of the following are the main goals of normalization EXCEPT:

		minimize data redundancy.
		simplify the enforcement of referential integrity.
		maximize storage space.
		make it easier to maintain data.

2 points

Question 13

A ________ defines or constrains some aspect of the business.

		business constraint
		business structure
		business control
		business rule

2 points

Question 14

Data is represented in the form of:

		data trees.
		tables.
		data notes.
		chairs.

2 points

Question 15

Data structures include data organized in the form of tables with rows and columns.

True

False

2 points

Question 16

An attribute that must have a value for every entity (or relationship) instance is a(n):

		composite attribute.
		optional attribute.
		required attribute.
		multivalued attribute.

2 points

Question 17

The following image represents what type of relationship

		one through many on the left and one and only one on the right
		zero through many on the left and one and only one on the right
		one through many on the left and zero to one on the right
		zero through many on the left and zero to one on the right

2 points

Question 18

In the SQL language, the ________ statement is used to retrieve data from the database.

		GET DATA
		RETRIEVE DATA
		FETCH DATA
		SELECT

2 points

Question 19

In the diagram below depicts a(an)

		LEFT JOIN
		RIGHT JOIN
		FULL JOIN
		INNER JOIN

2 points

Question 20

A primary key whose value is unique across all relations is called a(n):

		global primary key
		enterprise key.
		inter-table primary key
		foreign global key

2 points

Question 21

A primary key that consists of more than one attribute is called a:

		foreign key.
		composite key.
		multivalued key.
		cardinal key.

2 points

Question 22

A database is an organized collection of ________ related data.

		logically
		physically
		loosely
		badly

2 points

Question 23

The number of entity types that participate in a Unary relationship is:

		zero.
		one.
		two.
		three.

2 points

Question 24

In the SQL language, the ________ statement is used to add new records to the database.

		INSERT INTO
		ADD TO
		APPEND RECORD
		ADD

2 points

Question 25

The most common types of entities are:

		strong entities.
		weak entities.
		associative entities.
		smush entities.

2 points

Question 26

A simultaneous relationship among the instances of three entity types is called a ________ relationship.

		ternary
		tertiary
		primary
		binary

2 points

Question 27

The query below will return

		all professors without courses
		all courses without professors
		all courses that have professors
		only courses

2 points

Question 28

A rule that CANNOT be violated by database users is called a:

		constraint.
		password.
		program.
		view.

2 points

Question 29

The number of entity types that participate in a relationship is called the:

		number.
		identifying characteristic.
		degree.
		cardinality.

2 points

Question 30

When all multivalued attributes have been removed from a relation, it is said to be in:

		first normal form.
		second normal form.
		Boyce-Codd normal form.
		third normal form.

2 points

Question 31

In a query and alternative name for an attribute or an entity is:

		synonym
		alternative
		alias
		nickname

2 points

Question 32

________ are established between entities in a well-structured database so that the desired information can be retrieved.

		Entities
		Relationships
		Lines
		Ties

2 points

Question 33

In the query below professorxcourses is an example of a(an):

		associative entity
		entity
		table
		all of the above

2 points

Question 34

An entity that associates the instances of one or more entity types and contains attributes specific to the relationships is called a(n):

		smush entity.
		build entity.
		gateway entity.
		associative entity.

2 points

Question 35

In the SQL language, the ________ statement is used to remove a table from the database.

		REMOVE TABLE
		DELETE TABLE
		DROP TABLE
		DELETE TABLE FROM

2 points

Question 36

The logical representation of an organization's data is called a(n):

		database model.
		database entity diagram.
		relationship systems design.
		entity-relationship model.

2 points

Question 37

In the diagram below depicts a(an)

		LEFT JOIN
		RIGHT JOIN
		FULL JOIN
		INNER JOIN

2 points

Question 38

The query below will return

		All professors regardless if they have courses and all courses regardless if they have students
		All professors regardless if they have courses
		All professors that have courses regardless if they have students.
		none of the above

2 points

Question 39

CHAR data type will be a fixed length string

True

False

2 points

Question 40

An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:

		link attribute
		link key
		foreign key
		foreign attribute

2 points

Question 41

Expressions not encapsulated within and aggregate function must be included in a(n):

		WHERE clause
		GROUP BY clause
		SELECT statement
		INNER JOIN

2 points

Question 42

A person's name, birthday, and social security number are all examples of:

		attributes.
		entities.
		relationships.
		descriptors.

2 points

Question 43

In the diagram below depicts a(an)

		LEFT JOIN
		RIGHT JOIN
		FULL JOIN
		INNER JOIN

2 points

Question 44

A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.

		enterprise view
		reporting document
		user view
		user snapshot

2 points

Question 45

In the SQL language, the ________ statement is used to update records in the database.

		SELECT
		CHANGE
		EDIT RECORD
		UPDATE

2 points

Question 46

In the SQL language, the ________ statement is used to remove records in the database.

		REMOVE FROM
		DELETE FROM
		DROP RECORD
		UPDATE DELETE FROM

2 points

Question 47

The following image represents what type of relationship

		one through many on the left and one and only one on the right
		zero through many on the left and one and only one on the right
		one through many on the left and zero to one on the right
		zero through many on the left and zero to one on the right

2 points

Question 48

In the query below, ProfName, CourseName and Student Name are examples of

		attributes
		aliases
		entities
		none of the above

2 points

Question 49

15. In the SQL language, the WHERE clause is used to:

		determine where the data comes from
		filter the data given a criteria
		determine if the is valid
		none of the above

2 points

Question 50

An attribute with a NOT NULL constraint is a required attribute

True

False

2 points

Save and Submit

Click Save and Submit to save and submit. Click Save All Answers to save all answers.

Take Test: Test 340

Content

Test Information

Instructions

Remaining Time:

Question Completion Status:

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25

Question 26

Question 27

Question 28

Question 29

Question 30

Question 31

Question 32

Question 33

Question 34

Question 35

Question 36

Question 37

Question 38

Question 39

Question 40

Question 41

Question 42

Question 43

Question 44

Question 45

Question 46

Question 47

Question 48

Question 49

Question 50

Save and Submit